package org.example.mybatisdemo2.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.example.mybatisdemo2.model.ArticleInfo;

@Mapper
public interface ArticleInfoMapper {
    @Select("SELECT * FROM articleinfo ta" +
            " LEFT JOIN userinfo tb ON ta.uid=tb.id" +
            " WHERE ta.id=#{articleId}")
    ArticleInfo queryArticleInfo(Integer articleId);
}
